SKILL DEVELOPMENT COMMITTEE- TEACHING AND RESEARCH-

CART TRAINING ON SPSS AND EXCEL

Date: 25.08.2020- 28.08.2020

Time: 2-4 PM

The Department of International Studies, Political Science and History under the esteemed guidance of Dr Manoharan N organized the CART Training by Dr Shashikumar N D, Assistant Professor as an extension of the activities that prelude and fall under the purview of Skill Development Sub-Committee Teaching and Research headed by Lakshmi Karlekar, Sumedha K and Sanjana BS.

Prior to the Google Meet, a survey was conducted with the students of III MAIS regarding their numerical opinions (1-unfavourbale to 5-favourable and in practice) for the following aspects-

    Name
    Email Address
    Gender
    Resident of
    How often you go outside of your residence?
    How much awareness you are having on precautions?
    Rate the network/internet facility at your residence?
    How much you like online classes?
    How much you like offline classes?

The Google Meet was conducted on the following topics-

    Day 1-  Excel Training

    Sorting data
    =count function
    =countif function
    Pivot Table

    Day 2- Excel Training

    Mean, Median, Mode, Standard Error, Standard Deviation, Simple Variants
    Kurtosis and Skewness
    Normal versus not normal distribution
    Non-parametric and Parametric : Rank and Pearson Correlation
    Regression Statistics
    T-Test: Paired Two Samples for Means

    Day 3- SPSS Training

    Data view, Variable View (type, measure, role)
    Analyse- Descriptive Statistics: Frequencies, Explore (Histogram functions)

    Day 4- SPSS Training

    Analyse- Mixed Models- Linear
    Analyse- Correlate- Bivariate
    Analyse- Regression
    Analyse- Non- Parametric Tests
    Transform- Rank Cases

Regular home assignments were given post the detailed explanation to keep a track on the learning process. The sessions by CART were indeed reaping rich benefits and qualifying students to do Quantitative Analysis for their Research Papers respectively.